<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>商品管理列表</title>
	<link rel="stylesheet" type="text/css" href="111.css">
</head>
<body>
	<form action="delete_lot.php" method="post">
			<table border="1">
				<caption><h4>商品列表</h4></caption>
				<tr>
					<td align="center" colspan="9"><a href="addwz.php">添加列表</a></td>
				</tr>
				<tr>
					<td>编号</td>
					<td>产品名称</td>
					<td>产品规格</td>
					<td>产品数量</td>
					<td>产品单价（元）</td>
					<td>产品生产厂商</td>
					<td>更新</td>
					<td>删除</td>
					<td>批量删除</td>
				</tr>
		<?php
include 'conn.php';
$result = mysqli_query($conn, "select * from shop");
while ($arr = mysqli_fetch_array($result)) {
	?>

		<tr>
			<td><?php echo $arr[0] ?></td>
			<td><?php echo $arr[1] ?></td>
			<td><?php echo $arr[2] ?></td>
			<td><?php echo $arr[3] ?></td>
			<td><?php echo $arr[4] ?></td>
			<td><?php echo $arr[5] ?></td>
			<td><a href="update.php?id=<?php echo $arr[0] ?>">更新</a></td>
			<td><a href="delete.php?id=<?php echo $arr[0] ?>">删除</a></td>
			<td><input type="checkbox" name="delete[]" value="<?php echo $arr[0] ?>"></td>
		</tr>

		<?php }?>
		<tr>
			<td align="right" colspan="9">
				<input type="submit" name="提交" value="批量删除">
			</td>
		</tr>
			</table>
	</form>
</body>
</html>